# -*- coding: utf-8 -*-
from db.mysql import MysqlClient
from common.helper import Helper
class Arrangement( object ):
    def __init__(self):
        self.mysql = MysqlClient()
        self.name = "康爱卫士老年恶性肿瘤疾病保险"

    def pullData(self, data={}):
        for item in Helper.selectData(self.name, self.mysql):
            if item["payType"] == "年缴":
                payType = "年交"
            elif item["payType"] == "月交":
                pass


            data["name"] = self.name
            data["company"] = "中国太平"
            data["year"] = item["year"]
            data["gender"] = "1" if item["gender"] == "M" else "0"
            data["money"] = str(int(int(item["money"])/10000)) + "w"
            data["expire"] = item["expire"]

if __name__ == '__main__':

    a = Arrangement()
    a.pullData()